import pymysql
import pandas as pd

db = pymysql.connect(host='localhost',port=3306,user='root',passwd='root',db='python_database')
# 创建一个游标对象
cursor = db.cursor()
sql='INSERT INTO rng_(Time,敌人,比分,历史胜率) values ()'

da = cursor.execute(sql)
db.commit()

sql = 'DELETE FROM rng_ '
SQL = 'TRUNCATE TABLE RNG'
SQL=' UPDATE RNG_ SET Time= WHERE 比分='
sql = 'select * from rng_'

da = cursor.fetchall()

data = pd.read_sql('SELECT * FROM rng_',db)



